Dataset statistics
| Number of variables | 16 |
|---|---|
| Number of observations | 46428 |
| Missing cells | 18400 |
| Missing cells (%) | 2.5% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 6.0 MiB |
| Average record size in memory | 136.0 B |
Variable types
| Numeric | 10 |
|---|---|
| Text | 3 |
| Categorical | 2 |
| DateTime | 1 |
host_id is highly overall correlated with id | High correlation |
id is highly overall correlated with host_id | High correlation |
latitude is highly overall correlated with neighbourhood_group | High correlation |
longitude is highly overall correlated with neighbourhood_group | High correlation |
neighbourhood_group is highly overall correlated with latitude and 1 other fields | High correlation |
number_of_reviews is highly overall correlated with reviews_per_month | High correlation |
price is highly overall correlated with room_type | High correlation |
reviews_per_month is highly overall correlated with number_of_reviews | High correlation |
room_type is highly overall correlated with price | High correlation |
last_review has 9182 (19.8%) missing values | Missing |
reviews_per_month has 9182 (19.8%) missing values | Missing |
id has unique values | Unique |
minimum_nights has 12148 (26.2%) zeros | Zeros |
number_of_reviews has 9182 (19.8%) zeros | Zeros |
availability_365 has 17005 (36.6%) zeros | Zeros |
Reproduction
| Analysis started | 2024-06-19 19:02:05.850946 |
|---|---|
| Analysis finished | 2024-06-19 19:02:41.342232 |
| Duration | 35.49 seconds |
| Software version | ydata-profiling v0.0.dev0 |
| Download configuration | config.json |
id
Real number (ℝ)
HIGH CORRELATION UNIQUE
| Distinct | 46428 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 18918078 |
| Minimum | 2539 |
|---|---|
| Maximum | 36487245 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 725.4 KiB |
Quantile statistics
| Minimum | 2539 |
|---|---|
| 5-th percentile | 1209898.9 |
| Q1 | 9445461.2 |
| median | 19544622 |
| Q3 | 28937774 |
| 95-th percentile | 35225452 |
| Maximum | 36487245 |
| Range | 36484706 |
| Interquartile range (IQR) | 19492312 |
Descriptive statistics
| Standard deviation | 10931202 |
|---|---|
| Coefficient of variation (CV) | 0.5778178 |
| Kurtosis | -1.2191019 |
| Mean | 18918078 |
| Median Absolute Deviation (MAD) | 9799792.5 |
| Skewness | -0.080743829 |
| Sum | 8.7832853 × 1011 |
| Variance | 1.1949118 × 1014 |
| Monotonicity | Strictly increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2539 | 1 | < 0.1% |
| 25308563 | 1 | < 0.1% |
| 25309799 | 1 | < 0.1% |
| 25310242 | 1 | < 0.1% |
| 25310404 | 1 | < 0.1% |
| 25310497 | 1 | < 0.1% |
| 25311740 | 1 | < 0.1% |
| 25312773 | 1 | < 0.1% |
| 25313204 | 1 | < 0.1% |
| 25313748 | 1 | < 0.1% |
| Other values (46418) | 46418 |
| Value | Count | Frequency (%) |
| 2539 | 1 | |
| 2595 | 1 | |
| 3647 | 1 | |
| 3831 | 1 | |
| 5022 | 1 | |
| 5099 | 1 | |
| 5121 | 1 | |
| 5178 | 1 | |
| 5203 | 1 | |
| 5238 | 1 |
| Value | Count | Frequency (%) |
| 36487245 | 1 | |
| 36485609 | 1 | |
| 36485431 | 1 | |
| 36485057 | 1 | |
| 36484665 | 1 | |
| 36484363 | 1 | |
| 36484087 | 1 | |
| 36483152 | 1 | |
| 36483010 | 1 | |
| 36482809 | 1 |
name
Text
| Distinct | 45489 |
|---|---|
| Distinct (%) | 98.0% |
| Missing | 15 |
| Missing (%) | < 0.1% |
| Memory size | 725.4 KiB |
Length
| Max length | 179 |
|---|---|
| Median length | 73 |
| Mean length | 36.76735 |
| Min length | 1 |
Characters and Unicode
| Total characters | 1706483 |
|---|---|
| Distinct characters | 768 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 44878 ? |
|---|---|
| Unique (%) | 96.7% |
Sample
| 1st row | Clean & quiet apt home by the park |
|---|---|
| 2nd row | Skylit Midtown Castle |
| 3rd row | THE VILLAGE OF HARLEM....NEW YORK ! |
| 4th row | Cozy Entire Floor of Brownstone |
| 5th row | Entire Apt: Spacious Studio/Loft by central park |
| Value | Count | Frequency (%) |
| in | 16203 | 5.7% |
| room | 9976 | 3.5% |
| 7815 | 2.8% | |
| bedroom | 7283 | 2.6% |
| private | 7022 | 2.5% |
| apartment | 6461 | 2.3% |
| cozy | 4946 | 1.8% |
| apt | 4410 | 1.6% |
| brooklyn | 3918 | 1.4% |
| studio | 3897 | 1.4% |
| Other values (11921) | 210490 |
Most occurring characters
| Value | Count | Frequency (%) |
| 237569 | 13.9% | |
| e | 117726 | 6.9% |
| o | 116911 | 6.9% |
| t | 100052 | 5.9% |
| a | 98692 | 5.8% |
| r | 93300 | 5.5% |
| i | 90377 | 5.3% |
| n | 90086 | 5.3% |
| l | 48969 | 2.9% |
| m | 47334 | 2.8% |
| Other values (758) | 665467 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1706483 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 237569 | 13.9% | |
| e | 117726 | 6.9% |
| o | 116911 | 6.9% |
| t | 100052 | 5.9% |
| a | 98692 | 5.8% |
| r | 93300 | 5.5% |
| i | 90377 | 5.3% |
| n | 90086 | 5.3% |
| l | 48969 | 2.9% |
| m | 47334 | 2.8% |
| Other values (758) | 665467 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1706483 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 237569 | 13.9% | |
| e | 117726 | 6.9% |
| o | 116911 | 6.9% |
| t | 100052 | 5.9% |
| a | 98692 | 5.8% |
| r | 93300 | 5.5% |
| i | 90377 | 5.3% |
| n | 90086 | 5.3% |
| l | 48969 | 2.9% |
| m | 47334 | 2.8% |
| Other values (758) | 665467 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1706483 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 237569 | 13.9% | |
| e | 117726 | 6.9% |
| o | 116911 | 6.9% |
| t | 100052 | 5.9% |
| a | 98692 | 5.8% |
| r | 93300 | 5.5% |
| i | 90377 | 5.3% |
| n | 90086 | 5.3% |
| l | 48969 | 2.9% |
| m | 47334 | 2.8% |
| Other values (758) | 665467 |
host_id
Real number (ℝ)
HIGH CORRELATION
| Distinct | 35770 |
|---|---|
| Distinct (%) | 77.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 66451005 |
| Minimum | 2438 |
|---|---|
| Maximum | 2.7432131 × 108 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 725.4 KiB |
Quantile statistics
| Minimum | 2438 |
|---|---|
| 5-th percentile | 807362.4 |
| Q1 | 7719136.2 |
| median | 30321518 |
| Q3 | 1.0564047 × 108 |
| 95-th percentile | 2.3890395 × 108 |
| Maximum | 2.7432131 × 108 |
| Range | 2.7431888 × 108 |
| Interquartile range (IQR) | 97921335 |
Descriptive statistics
| Standard deviation | 77691273 |
|---|---|
| Coefficient of variation (CV) | 1.1691512 |
| Kurtosis | 0.26563043 |
| Mean | 66451005 |
| Median Absolute Deviation (MAD) | 27027080 |
| Skewness | 1.2359882 |
| Sum | 3.0851873 × 1012 |
| Variance | 6.0359339 × 1015 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 219517861 | 272 | 0.6% |
| 107434423 | 192 | 0.4% |
| 137358866 | 103 | 0.2% |
| 30283594 | 98 | 0.2% |
| 12243051 | 95 | 0.2% |
| 16098958 | 91 | 0.2% |
| 61391963 | 91 | 0.2% |
| 22541573 | 87 | 0.2% |
| 7503643 | 52 | 0.1% |
| 1475015 | 52 | 0.1% |
| Other values (35760) | 45295 |
| Value | Count | Frequency (%) |
| 2438 | 1 | < 0.1% |
| 2571 | 1 | < 0.1% |
| 2787 | 6 | |
| 2845 | 2 | < 0.1% |
| 2868 | 1 | < 0.1% |
| 2881 | 2 | < 0.1% |
| 3151 | 1 | < 0.1% |
| 3211 | 1 | < 0.1% |
| 3415 | 1 | < 0.1% |
| 3563 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 274321313 | 1 | |
| 274311461 | 1 | |
| 274307600 | 1 | |
| 274298453 | 1 | |
| 274273284 | 1 | |
| 274225617 | 1 | |
| 274195458 | 1 | |
| 274188386 | 1 | |
| 274103383 | 1 | |
| 274040642 | 1 |
host_name
Text
| Distinct | 11081 |
|---|---|
| Distinct (%) | 23.9% |
| Missing | 21 |
| Missing (%) | < 0.1% |
| Memory size | 725.4 KiB |
Length
| Max length | 35 |
|---|---|
| Median length | 31 |
| Mean length | 6.1095955 |
| Min length | 1 |
Characters and Unicode
| Total characters | 283528 |
|---|---|
| Distinct characters | 199 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 6646 ? |
|---|---|
| Unique (%) | 14.3% |
Sample
| 1st row | John |
|---|---|
| 2nd row | Jennifer |
| 3rd row | Elisabeth |
| 4th row | LisaRoxanne |
| 5th row | Laura |
| Value | Count | Frequency (%) |
| 1055 | 2.0% | |
| and | 589 | 1.1% |
| michael | 438 | 0.8% |
| david | 416 | 0.8% |
| sonder | 367 | 0.7% |
| john | 319 | 0.6% |
| alex | 309 | 0.6% |
| laura | 284 | 0.5% |
| nyc | 282 | 0.5% |
| maria | 234 | 0.5% |
| Other values (9966) | 47391 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 36141 | 12.7% |
| e | 27173 | 9.6% |
| i | 23124 | 8.2% |
| n | 22810 | 8.0% |
| r | 16949 | 6.0% |
| l | 14519 | 5.1% |
| o | 12101 | 4.3% |
| t | 8937 | 3.2% |
| s | 8673 | 3.1% |
| h | 8593 | 3.0% |
| Other values (189) | 104508 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 283528 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 36141 | 12.7% |
| e | 27173 | 9.6% |
| i | 23124 | 8.2% |
| n | 22810 | 8.0% |
| r | 16949 | 6.0% |
| l | 14519 | 5.1% |
| o | 12101 | 4.3% |
| t | 8937 | 3.2% |
| s | 8673 | 3.1% |
| h | 8593 | 3.0% |
| Other values (189) | 104508 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 283528 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 36141 | 12.7% |
| e | 27173 | 9.6% |
| i | 23124 | 8.2% |
| n | 22810 | 8.0% |
| r | 16949 | 6.0% |
| l | 14519 | 5.1% |
| o | 12101 | 4.3% |
| t | 8937 | 3.2% |
| s | 8673 | 3.1% |
| h | 8593 | 3.0% |
| Other values (189) | 104508 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 283528 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 36141 | 12.7% |
| e | 27173 | 9.6% |
| i | 23124 | 8.2% |
| n | 22810 | 8.0% |
| r | 16949 | 6.0% |
| l | 14519 | 5.1% |
| o | 12101 | 4.3% |
| t | 8937 | 3.2% |
| s | 8673 | 3.1% |
| h | 8593 | 3.0% |
| Other values (189) | 104508 |
neighbourhood_group
Categorical
HIGH CORRELATION
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 725.4 KiB |
| Manhattan | |
|---|---|
| Brooklyn | |
| Queens | |
| Bronx | 1072 |
| Staten Island | 365 |
Length
| Max length | 13 |
|---|---|
| Median length | 9 |
| Mean length | 8.1570604 |
| Min length | 5 |
Characters and Unicode
| Total characters | 378716 |
|---|---|
| Distinct characters | 20 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Brooklyn |
|---|---|
| 2nd row | Manhattan |
| 3rd row | Manhattan |
| 4th row | Brooklyn |
| 5th row | Manhattan |
Common Values
| Value | Count | Frequency (%) |
| Manhattan | 19855 | |
| Brooklyn | 19550 | |
| Queens | 5586 | 12.0% |
| Bronx | 1072 | 2.3% |
| Staten Island | 365 | 0.8% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| manhattan | 19855 | |
| brooklyn | 19550 | |
| queens | 5586 | 11.9% |
| bronx | 1072 | 2.3% |
| staten | 365 | 0.8% |
| island | 365 | 0.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 66648 | |
| a | 60295 | |
| t | 40440 | |
| o | 40172 | |
| B | 20622 | 5.4% |
| r | 20622 | 5.4% |
| l | 19915 | 5.3% |
| M | 19855 | 5.2% |
| h | 19855 | 5.2% |
| y | 19550 | 5.2% |
| Other values (10) | 50742 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 378716 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| n | 66648 | |
| a | 60295 | |
| t | 40440 | |
| o | 40172 | |
| B | 20622 | 5.4% |
| r | 20622 | 5.4% |
| l | 19915 | 5.3% |
| M | 19855 | 5.2% |
| h | 19855 | 5.2% |
| y | 19550 | 5.2% |
| Other values (10) | 50742 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 378716 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| n | 66648 | |
| a | 60295 | |
| t | 40440 | |
| o | 40172 | |
| B | 20622 | 5.4% |
| r | 20622 | 5.4% |
| l | 19915 | 5.3% |
| M | 19855 | 5.2% |
| h | 19855 | 5.2% |
| y | 19550 | 5.2% |
| Other values (10) | 50742 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 378716 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| n | 66648 | |
| a | 60295 | |
| t | 40440 | |
| o | 40172 | |
| B | 20622 | 5.4% |
| r | 20622 | 5.4% |
| l | 19915 | 5.3% |
| M | 19855 | 5.2% |
| h | 19855 | 5.2% |
| y | 19550 | 5.2% |
| Other values (10) | 50742 |
neighbourhood
Text
| Distinct | 219 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 725.4 KiB |
Length
| Max length | 26 |
|---|---|
| Median length | 17 |
| Mean length | 11.925993 |
| Min length | 4 |
Characters and Unicode
| Total characters | 553700 |
|---|---|
| Distinct characters | 54 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 4 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Kensington |
|---|---|
| 2nd row | Midtown |
| 3rd row | Harlem |
| 4th row | Clinton Hill |
| 5th row | East Harlem |
| Value | Count | Frequency (%) |
| east | 6298 | 8.4% |
| side | 4376 | 5.8% |
| williamsburg | 3771 | 5.0% |
| harlem | 3693 | 4.9% |
| bedford-stuyvesant | 3647 | 4.9% |
| upper | 3506 | 4.7% |
| heights | 3504 | 4.7% |
| village | 2905 | 3.9% |
| west | 2502 | 3.3% |
| bushwick | 2442 | 3.3% |
| Other values (231) | 38317 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 50730 | 9.2% |
| i | 39813 | 7.2% |
| s | 37999 | 6.9% |
| t | 36585 | 6.6% |
| a | 35885 | 6.5% |
| l | 32481 | 5.9% |
| r | 32219 | 5.8% |
| 28533 | 5.2% | |
| n | 24857 | 4.5% |
| o | 22938 | 4.1% |
| Other values (44) | 211660 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 553700 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 50730 | 9.2% |
| i | 39813 | 7.2% |
| s | 37999 | 6.9% |
| t | 36585 | 6.6% |
| a | 35885 | 6.5% |
| l | 32481 | 5.9% |
| r | 32219 | 5.8% |
| 28533 | 5.2% | |
| n | 24857 | 4.5% |
| o | 22938 | 4.1% |
| Other values (44) | 211660 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 553700 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 50730 | 9.2% |
| i | 39813 | 7.2% |
| s | 37999 | 6.9% |
| t | 36585 | 6.6% |
| a | 35885 | 6.5% |
| l | 32481 | 5.9% |
| r | 32219 | 5.8% |
| 28533 | 5.2% | |
| n | 24857 | 4.5% |
| o | 22938 | 4.1% |
| Other values (44) | 211660 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 553700 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 50730 | 9.2% |
| i | 39813 | 7.2% |
| s | 37999 | 6.9% |
| t | 36585 | 6.6% |
| a | 35885 | 6.5% |
| l | 32481 | 5.9% |
| r | 32219 | 5.8% |
| 28533 | 5.2% | |
| n | 24857 | 4.5% |
| o | 22938 | 4.1% |
| Other values (44) | 211660 |
latitude
Real number (ℝ)
HIGH CORRELATION
| Distinct | 18791 |
|---|---|
| Distinct (%) | 40.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 40.728572 |
| Minimum | 40.49979 |
|---|---|
| Maximum | 40.91306 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 725.4 KiB |
Quantile statistics
| Minimum | 40.49979 |
|---|---|
| 5-th percentile | 40.64538 |
| Q1 | 40.68936 |
| median | 40.72201 |
| Q3 | 40.76333 |
| 95-th percentile | 40.826463 |
| Maximum | 40.91306 |
| Range | 0.41327 |
| Interquartile range (IQR) | 0.07397 |
Descriptive statistics
| Standard deviation | 0.055190472 |
|---|---|
| Coefficient of variation (CV) | 0.00135508 |
| Kurtosis | 0.099724991 |
| Mean | 40.728572 |
| Median Absolute Deviation (MAD) | 0.03641 |
| Skewness | 0.25836604 |
| Sum | 1890946.1 |
| Variance | 0.0030459882 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 40.71813 | 18 | < 0.1% |
| 40.68444 | 13 | < 0.1% |
| 40.68634 | 13 | < 0.1% |
| 40.69414 | 13 | < 0.1% |
| 40.71171 | 12 | < 0.1% |
| 40.68537 | 12 | < 0.1% |
| 40.71353 | 12 | < 0.1% |
| 40.7191 | 11 | < 0.1% |
| 40.69054 | 11 | < 0.1% |
| 40.71923 | 11 | < 0.1% |
| Other values (18781) | 46302 |
| Value | Count | Frequency (%) |
| 40.49979 | 1 | |
| 40.50641 | 1 | |
| 40.50708 | 1 | |
| 40.50868 | 1 | |
| 40.50873 | 1 | |
| 40.50943 | 1 | |
| 40.51133 | 1 | |
| 40.52211 | 1 | |
| 40.52293 | 1 | |
| 40.527 | 1 |
| Value | Count | Frequency (%) |
| 40.91306 | 1 | |
| 40.91234 | 1 | |
| 40.91169 | 1 | |
| 40.91167 | 1 | |
| 40.90804 | 1 | |
| 40.90734 | 1 | |
| 40.90527 | 1 | |
| 40.90484 | 1 | |
| 40.90406 | 1 | |
| 40.90391 | 1 |
longitude
Real number (ℝ)
HIGH CORRELATION
| Distinct | 14563 |
|---|---|
| Distinct (%) | 31.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -73.950968 |
| Minimum | -74.24442 |
|---|---|
| Maximum | -73.71299 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 46428 |
| Negative (%) | 100.0% |
| Memory size | 725.4 KiB |
Quantile statistics
| Minimum | -74.24442 |
|---|---|
| 5-th percentile | -74.00326 |
| Q1 | -73.9821 |
| median | -73.95457 |
| Q3 | -73.934628 |
| 95-th percentile | -73.86389 |
| Maximum | -73.71299 |
| Range | 0.53143 |
| Interquartile range (IQR) | 0.0474725 |
Descriptive statistics
| Standard deviation | 0.046385832 |
|---|---|
| Coefficient of variation (CV) | -0.00062725119 |
| Kurtosis | 4.9394791 |
| Mean | -73.950968 |
| Median Absolute Deviation (MAD) | 0.02488 |
| Skewness | 1.2497163 |
| Sum | -3433395.5 |
| Variance | 0.0021516454 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -73.95677 | 18 | < 0.1% |
| -73.95427 | 17 | < 0.1% |
| -73.95332 | 16 | < 0.1% |
| -73.95136 | 16 | < 0.1% |
| -73.9506 | 16 | < 0.1% |
| -73.94791 | 16 | < 0.1% |
| -73.95405 | 16 | < 0.1% |
| -73.95725 | 15 | < 0.1% |
| -73.98439 | 15 | < 0.1% |
| -73.95742 | 15 | < 0.1% |
| Other values (14553) | 46268 |
| Value | Count | Frequency (%) |
| -74.24442 | 1 | |
| -74.24285 | 1 | |
| -74.24084 | 1 | |
| -74.23986 | 1 | |
| -74.23914 | 1 | |
| -74.23803 | 1 | |
| -74.23059 | 1 | |
| -74.21238 | 1 | |
| -74.21017 | 1 | |
| -74.20941 | 1 |
| Value | Count | Frequency (%) |
| -73.71299 | 1 | |
| -73.7169 | 1 | |
| -73.71795 | 1 | |
| -73.71829 | 1 | |
| -73.71928 | 1 | |
| -73.72173 | 1 | |
| -73.72179 | 1 | |
| -73.72247 | 1 | |
| -73.72435 | 1 | |
| -73.72581 | 1 |
room_type
Categorical
HIGH CORRELATION
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 725.4 KiB |
| Entire home/apt | |
|---|---|
| Private room | |
| Shared room | 1140 |
Length
| Max length | 15 |
|---|---|
| Median length | 15 |
| Mean length | 13.477901 |
| Min length | 11 |
Characters and Unicode
| Total characters | 625752 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Private room |
|---|---|
| 2nd row | Entire home/apt |
| 3rd row | Private room |
| 4th row | Entire home/apt |
| 5th row | Entire home/apt |
Common Values
| Value | Count | Frequency (%) |
| Entire home/apt | 23252 | |
| Private room | 22036 | |
| Shared room | 1140 | 2.5% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| entire | 23252 | |
| home/apt | 23252 | |
| room | 23176 | |
| private | 22036 | |
| shared | 1140 | 1.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 69680 | |
| o | 69604 | |
| r | 69604 | |
| t | 68540 | |
| a | 46428 | 7.4% |
| 46428 | 7.4% | |
| m | 46428 | 7.4% |
| i | 45288 | 7.2% |
| h | 24392 | 3.9% |
| p | 23252 | 3.7% |
| Other values (7) | 116108 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 625752 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 69680 | |
| o | 69604 | |
| r | 69604 | |
| t | 68540 | |
| a | 46428 | 7.4% |
| 46428 | 7.4% | |
| m | 46428 | 7.4% |
| i | 45288 | 7.2% |
| h | 24392 | 3.9% |
| p | 23252 | 3.7% |
| Other values (7) | 116108 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 625752 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 69680 | |
| o | 69604 | |
| r | 69604 | |
| t | 68540 | |
| a | 46428 | 7.4% |
| 46428 | 7.4% | |
| m | 46428 | 7.4% |
| i | 45288 | 7.2% |
| h | 24392 | 3.9% |
| p | 23252 | 3.7% |
| Other values (7) | 116108 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 625752 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 69680 | |
| o | 69604 | |
| r | 69604 | |
| t | 68540 | |
| a | 46428 | 7.4% |
| 46428 | 7.4% | |
| m | 46428 | 7.4% |
| i | 45288 | 7.2% |
| h | 24392 | 3.9% |
| p | 23252 | 3.7% |
| Other values (7) | 116108 |
price
Real number (ℝ)
HIGH CORRELATION
| Distinct | 337 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 122.53802 |
| Minimum | 10 |
|---|---|
| Maximum | 350 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 725.4 KiB |
Quantile statistics
| Minimum | 10 |
|---|---|
| 5-th percentile | 40 |
| Q1 | 65 |
| median | 100 |
| Q3 | 160 |
| 95-th percentile | 275 |
| Maximum | 350 |
| Range | 340 |
| Interquartile range (IQR) | 95 |
Descriptive statistics
| Standard deviation | 71.862581 |
|---|---|
| Coefficient of variation (CV) | 0.58645132 |
| Kurtosis | 0.5184784 |
| Mean | 122.53802 |
| Median Absolute Deviation (MAD) | 44 |
| Skewness | 1.0306644 |
| Sum | 5689195 |
| Variance | 5164.2306 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 100 | 2051 | 4.4% |
| 150 | 2047 | 4.4% |
| 50 | 1534 | 3.3% |
| 60 | 1458 | 3.1% |
| 200 | 1401 | 3.0% |
| 75 | 1370 | 3.0% |
| 80 | 1272 | 2.7% |
| 65 | 1190 | 2.6% |
| 70 | 1170 | 2.5% |
| 120 | 1130 | 2.4% |
| Other values (327) | 31805 |
| Value | Count | Frequency (%) |
| 10 | 17 | |
| 11 | 3 | < 0.1% |
| 12 | 4 | < 0.1% |
| 13 | 1 | < 0.1% |
| 15 | 6 | < 0.1% |
| 16 | 6 | < 0.1% |
| 18 | 2 | < 0.1% |
| 19 | 4 | < 0.1% |
| 20 | 33 | |
| 21 | 6 | < 0.1% |
| Value | Count | Frequency (%) |
| 350 | 381 | |
| 349 | 45 | 0.1% |
| 348 | 3 | < 0.1% |
| 347 | 4 | < 0.1% |
| 346 | 2 | < 0.1% |
| 345 | 25 | 0.1% |
| 344 | 1 | < 0.1% |
| 343 | 4 | < 0.1% |
| 342 | 1 | < 0.1% |
| 341 | 4 | < 0.1% |
minimum_nights
Real number (ℝ)
ZEROS
| Distinct | 107 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.1295348 |
| Minimum | 0 |
|---|---|
| Maximum | 7.1308988 |
| Zeros | 12148 |
| Zeros (%) | 26.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 725.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.69314718 |
| Q3 | 1.6094379 |
| 95-th percentile | 3.4011974 |
| Maximum | 7.1308988 |
| Range | 7.1308988 |
| Interquartile range (IQR) | 1.6094379 |
Descriptive statistics
| Standard deviation | 1.0691072 |
|---|---|
| Coefficient of variation (CV) | 0.94650216 |
| Kurtosis | 0.84951091 |
| Mean | 1.1295348 |
| Median Absolute Deviation (MAD) | 0.69314718 |
| Skewness | 1.1145044 |
| Sum | 52442.043 |
| Variance | 1.1429901 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 12148 | |
| 0.6931471806 | 11199 | |
| 1.098612289 | 7506 | |
| 3.401197382 | 3534 | 7.6% |
| 1.386294361 | 3106 | 6.7% |
| 1.609437912 | 2854 | 6.1% |
| 1.945910149 | 1975 | 4.3% |
| 1.791759469 | 694 | 1.5% |
| 2.63905733 | 543 | 1.2% |
| 2.302585093 | 464 | 1.0% |
| Other values (97) | 2405 | 5.2% |
| Value | Count | Frequency (%) |
| 0 | 12148 | |
| 0.6931471806 | 11199 | |
| 1.098612289 | 7506 | |
| 1.386294361 | 3106 | 6.7% |
| 1.609437912 | 2854 | 6.1% |
| 1.791759469 | 694 | 1.5% |
| 1.945910149 | 1975 | 4.3% |
| 2.079441542 | 129 | 0.3% |
| 2.197224577 | 79 | 0.2% |
| 2.302585093 | 464 | 1.0% |
| Value | Count | Frequency (%) |
| 7.13089883 | 1 | < 0.1% |
| 6.906754779 | 3 | < 0.1% |
| 6.214608098 | 5 | < 0.1% |
| 6.173786104 | 1 | < 0.1% |
| 5.991464547 | 1 | < 0.1% |
| 5.913503006 | 1 | < 0.1% |
| 5.902633333 | 1 | < 0.1% |
| 5.899897354 | 24 | |
| 5.897153868 | 1 | < 0.1% |
| 5.886104031 | 5 | < 0.1% |
number_of_reviews
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 393 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23.827712 |
| Minimum | 0 |
|---|---|
| Maximum | 629 |
| Zeros | 9182 |
| Zeros (%) | 19.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 725.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 5 |
| Q3 | 24 |
| 95-th percentile | 116 |
| Maximum | 629 |
| Range | 629 |
| Interquartile range (IQR) | 23 |
Descriptive statistics
| Standard deviation | 45.190521 |
|---|---|
| Coefficient of variation (CV) | 1.8965531 |
| Kurtosis | 18.944347 |
| Mean | 23.827712 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 3.64035 |
| Sum | 1106273 |
| Variance | 2042.1832 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 9182 | |
| 1 | 4976 | 10.7% |
| 2 | 3318 | 7.1% |
| 3 | 2390 | 5.1% |
| 4 | 1918 | 4.1% |
| 5 | 1526 | 3.3% |
| 6 | 1297 | 2.8% |
| 7 | 1130 | 2.4% |
| 8 | 1080 | 2.3% |
| 9 | 924 | 2.0% |
| Other values (383) | 18687 |
| Value | Count | Frequency (%) |
| 0 | 9182 | |
| 1 | 4976 | |
| 2 | 3318 | 7.1% |
| 3 | 2390 | 5.1% |
| 4 | 1918 | 4.1% |
| 5 | 1526 | 3.3% |
| 6 | 1297 | 2.8% |
| 7 | 1130 | 2.4% |
| 8 | 1080 | 2.3% |
| 9 | 924 | 2.0% |
| Value | Count | Frequency (%) |
| 629 | 1 | |
| 607 | 1 | |
| 597 | 1 | |
| 594 | 1 | |
| 576 | 1 | |
| 543 | 1 | |
| 540 | 1 | |
| 510 | 1 | |
| 488 | 1 | |
| 480 | 1 |
last_review
Date
MISSING
| Distinct | 1754 |
|---|---|
| Distinct (%) | 4.7% |
| Missing | 9182 |
| Missing (%) | 19.8% |
| Memory size | 725.4 KiB |
| Minimum | 2011-03-28 00:00:00 |
|---|---|
| Maximum | 2019-07-08 00:00:00 |
Histogram with fixed size bins (bins=50)
reviews_per_month
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 936 |
|---|---|
| Distinct (%) | 2.5% |
| Missing | 9182 |
| Missing (%) | 19.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.377473 |
| Minimum | 0.01 |
|---|---|
| Maximum | 58.5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 725.4 KiB |
Quantile statistics
| Minimum | 0.01 |
|---|---|
| 5-th percentile | 0.04 |
| Q1 | 0.19 |
| median | 0.715 |
| Q3 | 2.02 |
| 95-th percentile | 4.67 |
| Maximum | 58.5 |
| Range | 58.49 |
| Interquartile range (IQR) | 1.83 |
Descriptive statistics
| Standard deviation | 1.6904934 |
|---|---|
| Coefficient of variation (CV) | 1.2272425 |
| Kurtosis | 43.099274 |
| Mean | 1.377473 |
| Median Absolute Deviation (MAD) | 0.615 |
| Skewness | 3.1549195 |
| Sum | 51305.36 |
| Variance | 2.8577679 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.02 | 886 | 1.9% |
| 0.05 | 856 | 1.8% |
| 1 | 828 | 1.8% |
| 0.03 | 772 | 1.7% |
| 0.04 | 639 | 1.4% |
| 0.16 | 638 | 1.4% |
| 0.08 | 580 | 1.2% |
| 0.09 | 564 | 1.2% |
| 0.06 | 557 | 1.2% |
| 0.11 | 527 | 1.1% |
| Other values (926) | 30399 | |
| (Missing) | 9182 | 19.8% |
| Value | Count | Frequency (%) |
| 0.01 | 40 | 0.1% |
| 0.02 | 886 | |
| 0.03 | 772 | |
| 0.04 | 639 | |
| 0.05 | 856 | |
| 0.06 | 557 | |
| 0.07 | 453 | |
| 0.08 | 580 | |
| 0.09 | 564 | |
| 0.1 | 438 |
| Value | Count | Frequency (%) |
| 58.5 | 1 | |
| 27.95 | 1 | |
| 20.94 | 1 | |
| 19.75 | 1 | |
| 17.82 | 1 | |
| 16.81 | 1 | |
| 16.22 | 1 | |
| 16.03 | 1 | |
| 15.78 | 1 | |
| 15.32 | 1 |
calculated_host_listings_count
Real number (ℝ)
| Distinct | 47 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.6725037 |
| Minimum | 1 |
|---|---|
| Maximum | 327 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 725.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 13 |
| Maximum | 327 |
| Range | 326 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 31.083436 |
|---|---|
| Coefficient of variation (CV) | 4.6584368 |
| Kurtosis | 75.60396 |
| Mean | 6.6725037 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 8.3505074 |
| Sum | 309791 |
| Variance | 966.18001 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=47)
| Value | Count | Frequency (%) |
| 1 | 30677 | |
| 2 | 6436 | 13.9% |
| 3 | 2745 | 5.9% |
| 4 | 1354 | 2.9% |
| 5 | 808 | 1.7% |
| 6 | 529 | 1.1% |
| 8 | 396 | 0.9% |
| 7 | 390 | 0.8% |
| 327 | 272 | 0.6% |
| 9 | 225 | 0.5% |
| Other values (37) | 2596 | 5.6% |
| Value | Count | Frequency (%) |
| 1 | 30677 | |
| 2 | 6436 | 13.9% |
| 3 | 2745 | 5.9% |
| 4 | 1354 | 2.9% |
| 5 | 808 | 1.7% |
| 6 | 529 | 1.1% |
| 7 | 390 | 0.8% |
| 8 | 396 | 0.9% |
| 9 | 225 | 0.5% |
| 10 | 203 | 0.4% |
| Value | Count | Frequency (%) |
| 327 | 272 | |
| 232 | 192 | |
| 121 | 98 | 0.2% |
| 103 | 103 | 0.2% |
| 96 | 186 | |
| 91 | 91 | 0.2% |
| 87 | 87 | 0.2% |
| 65 | 50 | 0.1% |
| 52 | 104 | 0.2% |
| 50 | 49 | 0.1% |
availability_365
Real number (ℝ)
ZEROS
| Distinct | 366 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 109.67685 |
| Minimum | 0 |
|---|---|
| Maximum | 365 |
| Zeros | 17005 |
| Zeros (%) | 36.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 725.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 40 |
| Q3 | 217 |
| 95-th percentile | 358 |
| Maximum | 365 |
| Range | 365 |
| Interquartile range (IQR) | 217 |
Descriptive statistics
| Standard deviation | 130.41395 |
|---|---|
| Coefficient of variation (CV) | 1.1890745 |
| Kurtosis | -0.92278392 |
| Mean | 109.67685 |
| Median Absolute Deviation (MAD) | 40 |
| Skewness | 0.80642813 |
| Sum | 5092077 |
| Variance | 17007.799 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 17005 | |
| 365 | 1122 | 2.4% |
| 364 | 430 | 0.9% |
| 1 | 397 | 0.9% |
| 89 | 334 | 0.7% |
| 5 | 333 | 0.7% |
| 3 | 296 | 0.6% |
| 179 | 273 | 0.6% |
| 90 | 270 | 0.6% |
| 2 | 254 | 0.5% |
| Other values (356) | 25714 |
| Value | Count | Frequency (%) |
| 0 | 17005 | |
| 1 | 397 | 0.9% |
| 2 | 254 | 0.5% |
| 3 | 296 | 0.6% |
| 4 | 227 | 0.5% |
| 5 | 333 | 0.7% |
| 6 | 240 | 0.5% |
| 7 | 212 | 0.5% |
| 8 | 228 | 0.5% |
| 9 | 187 | 0.4% |
| Value | Count | Frequency (%) |
| 365 | 1122 | |
| 364 | 430 | 0.9% |
| 363 | 215 | 0.5% |
| 362 | 150 | 0.3% |
| 361 | 101 | 0.2% |
| 360 | 95 | 0.2% |
| 359 | 127 | 0.3% |
| 358 | 160 | 0.3% |
| 357 | 83 | 0.2% |
| 356 | 73 | 0.2% |
| availability_365 | calculated_host_listings_count | host_id | id | latitude | longitude | minimum_nights | neighbourhood_group | number_of_reviews | price | reviews_per_month | room_type | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| availability_365 | 1.000 | 0.411 | 0.166 | 0.158 | -0.015 | 0.089 | 0.074 | 0.086 | 0.253 | 0.054 | 0.401 | 0.093 |
| calculated_host_listings_count | 0.411 | 1.000 | 0.145 | 0.135 | -0.000 | 0.068 | 0.064 | 0.088 | 0.065 | -0.123 | 0.155 | 0.097 |
| host_id | 0.166 | 0.145 | 1.000 | 0.552 | 0.044 | 0.125 | -0.136 | 0.103 | -0.122 | -0.100 | 0.262 | 0.098 |
| id | 0.158 | 0.135 | 0.552 | 1.000 | -0.001 | 0.084 | -0.061 | 0.065 | -0.306 | -0.041 | 0.355 | 0.071 |
| latitude | -0.015 | -0.000 | 0.044 | -0.001 | 1.000 | 0.043 | 0.020 | 0.539 | -0.039 | 0.130 | -0.026 | 0.109 |
| longitude | 0.089 | 0.068 | 0.125 | 0.084 | 0.043 | 1.000 | -0.119 | 0.652 | 0.072 | -0.423 | 0.129 | 0.146 |
| minimum_nights | 0.074 | 0.064 | -0.136 | -0.061 | 0.020 | -0.119 | 1.000 | 0.080 | -0.180 | 0.103 | -0.293 | 0.141 |
| neighbourhood_group | 0.086 | 0.088 | 0.103 | 0.065 | 0.539 | 0.652 | 0.080 | 1.000 | -0.015 | 0.114 | 0.046 | 0.115 |
| number_of_reviews | 0.253 | 0.065 | -0.122 | -0.306 | -0.039 | 0.072 | -0.180 | -0.015 | 1.000 | -0.026 | 0.714 | 0.022 |
| price | 0.054 | -0.123 | -0.100 | -0.041 | 0.130 | -0.423 | 0.103 | 0.114 | -0.026 | 1.000 | -0.020 | 0.503 |
| reviews_per_month | 0.401 | 0.155 | 0.262 | 0.355 | -0.026 | 0.129 | -0.293 | 0.046 | 0.714 | -0.020 | 1.000 | 0.028 |
| room_type | 0.093 | 0.097 | 0.098 | 0.071 | 0.109 | 0.146 | 0.141 | 0.115 | 0.022 | 0.503 | 0.028 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
| id | name | host_id | host_name | neighbourhood_group | neighbourhood | latitude | longitude | room_type | price | minimum_nights | number_of_reviews | last_review | reviews_per_month | calculated_host_listings_count | availability_365 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2539 | Clean & quiet apt home by the park | 2787 | John | Brooklyn | Kensington | 40.64749 | -73.97237 | Private room | 149 | 0.000000 | 9 | 2018-10-19 | 0.21 | 6 | 365 |
| 1 | 2595 | Skylit Midtown Castle | 2845 | Jennifer | Manhattan | Midtown | 40.75362 | -73.98377 | Entire home/apt | 225 | 0.000000 | 45 | 2019-05-21 | 0.38 | 2 | 355 |
| 2 | 3647 | THE VILLAGE OF HARLEM....NEW YORK ! | 4632 | Elisabeth | Manhattan | Harlem | 40.80902 | -73.94190 | Private room | 150 | 1.098612 | 0 | NaT | NaN | 1 | 365 |
| 3 | 3831 | Cozy Entire Floor of Brownstone | 4869 | LisaRoxanne | Brooklyn | Clinton Hill | 40.68514 | -73.95976 | Entire home/apt | 89 | 0.000000 | 270 | 2019-07-05 | 4.64 | 1 | 194 |
| 4 | 5022 | Entire Apt: Spacious Studio/Loft by central park | 7192 | Laura | Manhattan | East Harlem | 40.79851 | -73.94399 | Entire home/apt | 80 | 2.302585 | 9 | 2018-11-19 | 0.10 | 1 | 0 |
| 5 | 5099 | Large Cozy 1 BR Apartment In Midtown East | 7322 | Chris | Manhattan | Murray Hill | 40.74767 | -73.97500 | Entire home/apt | 200 | 1.098612 | 74 | 2019-06-22 | 0.59 | 1 | 129 |
| 6 | 5121 | BlissArtsSpace! | 7356 | Garon | Brooklyn | Bedford-Stuyvesant | 40.68688 | -73.95596 | Private room | 60 | 3.806662 | 49 | 2017-10-05 | 0.40 | 1 | 0 |
| 7 | 5178 | Large Furnished Room Near B'way | 8967 | Shunichi | Manhattan | Hell's Kitchen | 40.76489 | -73.98493 | Private room | 79 | 0.693147 | 430 | 2019-06-24 | 3.47 | 1 | 220 |
| 8 | 5203 | Cozy Clean Guest Room - Family Apt | 7490 | MaryEllen | Manhattan | Upper West Side | 40.80178 | -73.96723 | Private room | 79 | 0.693147 | 118 | 2017-07-21 | 0.99 | 1 | 0 |
| 9 | 5238 | Cute & Cozy Lower East Side 1 bdrm | 7549 | Ben | Manhattan | Chinatown | 40.71344 | -73.99037 | Entire home/apt | 150 | 0.000000 | 160 | 2019-06-09 | 1.33 | 4 | 188 |
| id | name | host_id | host_name | neighbourhood_group | neighbourhood | latitude | longitude | room_type | price | minimum_nights | number_of_reviews | last_review | reviews_per_month | calculated_host_listings_count | availability_365 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 48885 | 36482809 | Stunning Bedroom NYC! Walking to Central Park!! | 131529729 | Kendall | Manhattan | East Harlem | 40.79633 | -73.93605 | Private room | 75 | 0.693147 | 0 | NaT | NaN | 2 | 353 |
| 48886 | 36483010 | Comfy 1 Bedroom in Midtown East | 274311461 | Scott | Manhattan | Midtown | 40.75561 | -73.96723 | Entire home/apt | 200 | 1.791759 | 0 | NaT | NaN | 1 | 176 |
| 48887 | 36483152 | Garden Jewel Apartment in Williamsburg New York | 208514239 | Melki | Brooklyn | Williamsburg | 40.71232 | -73.94220 | Entire home/apt | 170 | 0.000000 | 0 | NaT | NaN | 3 | 365 |
| 48888 | 36484087 | Spacious Room w/ Private Rooftop, Central location | 274321313 | Kat | Manhattan | Hell's Kitchen | 40.76392 | -73.99183 | Private room | 125 | 1.386294 | 0 | NaT | NaN | 1 | 31 |
| 48889 | 36484363 | QUIT PRIVATE HOUSE | 107716952 | Michael | Queens | Jamaica | 40.69137 | -73.80844 | Private room | 65 | 0.000000 | 0 | NaT | NaN | 2 | 163 |
| 48890 | 36484665 | Charming one bedroom - newly renovated rowhouse | 8232441 | Sabrina | Brooklyn | Bedford-Stuyvesant | 40.67853 | -73.94995 | Private room | 70 | 0.693147 | 0 | NaT | NaN | 2 | 9 |
| 48891 | 36485057 | Affordable room in Bushwick/East Williamsburg | 6570630 | Marisol | Brooklyn | Bushwick | 40.70184 | -73.93317 | Private room | 40 | 1.386294 | 0 | NaT | NaN | 2 | 36 |
| 48892 | 36485431 | Sunny Studio at Historical Neighborhood | 23492952 | Ilgar & Aysel | Manhattan | Harlem | 40.81475 | -73.94867 | Entire home/apt | 115 | 2.302585 | 0 | NaT | NaN | 1 | 27 |
| 48893 | 36485609 | 43rd St. Time Square-cozy single bed | 30985759 | Taz | Manhattan | Hell's Kitchen | 40.75751 | -73.99112 | Shared room | 55 | 0.000000 | 0 | NaT | NaN | 6 | 2 |
| 48894 | 36487245 | Trendy duplex in the very heart of Hell's Kitchen | 68119814 | Christophe | Manhattan | Hell's Kitchen | 40.76404 | -73.98933 | Private room | 90 | 1.945910 | 0 | NaT | NaN | 1 | 23 |